When worksheets exist in an open file, Window > Worksheets becomes available. All the worksheets present in the indicated file are listed, and can be opened by selecting them from the sub-menu. Worksheets with a check mark are currently open. Worksheets can also be opened from the Resource Browser by selecting the worksheet from the list and selecting Open from the Resources menu.
A worksheet opens in a separate window; it can be resized, moved, and closed. Worksheets contain a separate menu and command icons (see Worksheet Commands).
Because an open worksheet is in a separate window, it is not printed with the drawing. To include a worksheet as part of a drawing, select the worksheet in the Resource Browser and click Worksheet on Drawing from the Resources menu. When the worksheet is open, the worksheet on the drawing displays as an “X.” When the worksheet is closed, the updated worksheet displays on the drawing. Double-click the worksheet from the drawing to open it. See Worksheets as Graphic Objects.
The worksheet appearance can be specified with a variety of formatting options (see Formatting Worksheet Cells). The format is retained when the worksheet is included on the drawing. The appearance of the worksheet background (fill, pen, and line thickness) can also be modified from the Attributes palette.
In a VectorWorks worksheet, rows are numbered sequentially starting with 1, and columns are labeled alphabetically starting with A. The cell’s row number and column letter indicate the spreadsheet cell address (database sub-rows display a blank address). Cells can contain text, numbers, or formulas.
When an empty worksheet is first created, all rows contain spreadsheet cells. Once created, database rows are marked with a diamond shape next to the row number. The database header row contains the criteria, while the database sub-rows represent the objects that meet the specified criteria. For more information on spreadsheet cells and database rows, see Worksheet Rows.